2014-04-21 - 12560.100 - Spec - Time Zone reporting #SalesDistribution

SPECIFICATIONS

12560.100 - Time Zone reporting

Purpose

---

To create Semantically partitioned Objects or InfoCubes for regionwise Reporting on COPA, Open Order, Contract and Condition Sources.

Admin Info

---

Purpose	Need to build region specific partitions in BW for regional reporting
Requested By	Mark Harris
Spec Created By	Chandramouli K
Spec Created Date	04/21/2014
Spec QA by	Uday Kumar P
Objects	COPA SPO, Open Order SPO, Contract SPO, Condition SPO
Document Status	Complete

References

---

Prior Tickets

10256.200

Documents

None

Functional Requirement

---

1. Need to create regionwise InfoCube and its Dataflow separately for COPA Source.
2. Need to create regionwise InfoCube and its Dataflow separately for Open Order Source.
3. Need to create regionwise InfoCube and its Dataflow separately for Contract Source.
4. Need to create regionwise InfoCube and its Dataflow separately for Condition Source.

Solution Summary

---

1. Need to create Semantically Partitioned object(SPO) with four partitions based on regions for COPA Source.
2. Need to create Semantically Partitioned object(SPO) with four partitions based on regions for Open Order Source.
3. Need to create Semantically Partitioned object(SPO) with four partitions based on regions for Contract Source.
4. Need to create Semantically Partitioned object(SPO) with four partitions based on regions for Condition Source.

Test Plan

SNo	Test Scenario	Expected Results
1	Check the above sources against NEC Standard Infoprovider development checklist.	Infoproviders should be successfully validated as per checklist.
2	Check if the data is loaded correctly as per the partitions defined.	Data should be correctly loaded and verified.

Solution Details

---

1. Need to create Semantically Partitioned Object(SPO) with four partitions based on regions for COPA Source and need to load data from ZIC_COPA(NEC COPA) InfoCube and ZDSOCOPA(COPA Inter Company DSO) daily.
2. Need to create Semantically Partitioned Object(SPO) with four partitions based on regions for Open Order Source and need to load data from ZAFSDDS1(AFS Sales Orders) DSO daily.
3. Need to create Semantically Partitioned Object(SPO) with four partitions based on regions for Contract Source and need to load data from ZAFSDDS1(AFS Sales Orders) DSO daily.
4. Need to create Semantically Partitioned Object(SPO) with four partitions based on regions for Condition Source and need to load data from ZSDC_OPN(Open Orders InfoCube) and ZSD_CONTR(Contract Order Cube) daily.
5. Need to create Process Chains for all the above sources to automate the data loads once the data validations is successful.

Issues

---

None